package pl.edu.pw.perg.compinfodb.xls;

import java.text.SimpleDateFormat;

public class XLSConstants {

	public static final int LOCATION_NOT_AVAILABLE = -1;
	
	public static final String FIELD_FIELD_NAME_COL = "f_field_name_col";
	
	public static final String TYPE_ELEMENT_TYPE_COL = "t_element_type_col";
	public static final String TYPE_PARENT_COL = "t_parent_col";
	public static final String TYPE_INPUTS_COL = "t_input_cons_col";
	public static final String TYPE_OUTPUTS_COL = "t_output_con_col";
	public static final String TYPE_FIELDS_COL = "t_fields_col";
	public static final String TYPE_CABLE_COL = "t_cable_flag_col";
	public static final String TYPE_FIRST_INDEX_IN_COL = "t_first_index_in_col";
	public static final String TYPE_FIRST_INDEX_OUT_COL = "t_first_index_out_col";
		
	public static final String HIST_MODULE_COL = "h_module_col";
	public static final String HIST_ELEMENT_COL = "h_element_col";
	public static final String HIST_DATE_COL = "h_date_col";
	public static final String HIST_COMMENT_COL = "h_comment_col";
	public static final String HIST_AUTHOR_COL = "h_author_col";
	
	public static final String STRUCT_ID_COL = "s_identifier_col";
	public static final String STRUCT_TYPE_COL = "s_type_col";
	public static final String STRUCT_PARENT_COL = "s_parent_col";
	public static final String STRUCT_LOCATION_COL = "s_position_col";
	
	public static final String ELT_TYPE_COL = "e_type_col";
	public static final String ELT_ID_COL = "e_identifier_col";
	public static final String ELT_LABEL_COL = "e_label_col";
	public static final String ELT_ATTRIBUTES_COL = "e_attributes_col";
	
	public static final String CON_OUT_ELT_COL = "c_out_el_col";
	public static final String CON_OUT_CON_COL = "c_out_con_col";
	public static final String CON_CBL_COL = "c_cable_col";
	public static final String CON_IN_CON_COL = "c_in_con_col";
	public static final String CON_IN_ELT_COL = "c_in_el_col";
	
	public static final String CN_TYPE_COL = "cn_type_col";
	public static final String CN_INPUT_INDEX_COL = "cn_input_index_col";
	public static final String CN_OUTPUT_INDEX_COL = "cn_output_index_col";
	public static final String CN_NAME_COL = "cn_name_col";
		
	public static final String CONNECTIONS_SHEET = "connections_sheet";
	public static final String MODULES_SHEET = "modules_sheet";
	public static final String STRUCTURE_SHEET = "structure_sheet";
	public static final String HISTORY_SHEET = "history_sheet";
	public static final String TYPES_SHEET = "types_sheet";
	public static final String FIELDS_SHEET = "fields_sheet";
	public static final String CONNECTOR_NAMES_SHEET = "connector_names_sheet";
	
	public static final String XLS_FILE_IMPORT = "xls_file_import";
	public static final String XLS_FILE_EXPORT = "xls_file_export";
//	public static final String PROPERTIES_FILE = "xls.properties";
//	public static final String TEST_PROPERTIES_FILE = "xls-test.properties";
	public static final String HEADER_ROWS = "header_rows";
		
	public static final SimpleDateFormat dateFormat = new SimpleDateFormat("dd-MM-yyyy HH:mm");
}
